﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="FundshareaccountJuniorIsa.aspx.vb" Inherits="webfinancegdrassign4.FundshareaccountJuniorIsa" %>
<%--SmartInvestor Project for University of Herts--%>
<%--Date: 01 December 2013--%>
<%--Version 1--%>
<%--Update 1 -  31st December 2013--%>
<%--Update 2 -  01 Jan 2014 - Changed file to have Cookie Policy as static content, fast to upload and not much to change unless something drastic has to change - Gene Da Rocha %>
 <%--Project Brief Description - This is a Smart Money Saver asp.net product using VB.net. It is intended to be used by Smart Money Savers who earn about a certain amount who want to make and save money and earn a certain amount for themselves--%>
<%--Program Brief Description - This is the contact site program file. It gives you basic contact information for Smart Investor. --%>
<%--Changes - Removed current Text --%>
<%--Changes - Added in a grid view field, connection field to database and table smartinvesto_info and field - cookiepolicy. It actually selects data from database to page--%>
<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
      <header>
        <br />
        <br />
        <br />
        <h1>Fund & Share A/C</h1>

           <%--Changes - Grid View and connection to database to select data Gene Da Rocha - 28th Dec 2013--%>
            
            <%--01 Jan 2014 - About.aspx - Gene Da Rocha - update - select url location for images on page.  --%>

             <%--03 Jan 2014 - About.aspx - Gene Da Rocha - update - Change Table Name to SMS_INFO from smartinvestor_info.  --%>
            <br /> 
                   <asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource002" AutoGenerateColumns="False" BorderStyle="None" GridLines="None" ShowHeader="False">
                <Columns>
                <asp:ImageField DataImageUrlField="about_image1" ControlStyle-Height="183" ControlStyle-Width="275">
                    <ControlStyle CssClass="image" />
                </asp:ImageField>

                <asp:ImageField DataImageUrlField="about_image2" ControlStyle-Height="183" ControlStyle-Width="275">
                        <ControlStyle CssClass="image" />
                 </asp:ImageField>

                 <asp:ImageField DataImageUrlField="about_image3" ControlStyle-Height="183" ControlStyle-Width="275">
                        <ControlStyle CssClass="image" />
                 </asp:ImageField>

                </Columns>
            </asp:GridView>
             <%--03 Jan 2014 - About.aspx - Gene Da Rocha - update - Change Table Name to SMS_INFO from smartinvestor_info.  --%>
            <asp:SqlDataSource ID="SqlDataSource002" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString002 %>" ProviderName="<%$ ConnectionStrings:ConnectionString002.ProviderName %>" SelectCommand="SELECT [about_image1], [about_image2], [about_image3] FROM [sms_images]"></asp:SqlDataSource>
     
                <asp:GridView ID="GridView3" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" BorderStyle="None" CellPadding="5" CellSpacing="5" GridLines="None" Font-Names="Arial" Font-Size="Small">
                    <Columns>
                        <asp:BoundField DataField="about"  SortExpression="about"  />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString15 %>" ProviderName="<%$ ConnectionStrings:ConnectionString15.ProviderName %>" SelectCommand="SELECT [about] FROM [sms_moneysubtype] WHERE ([ID] = 5)">
                </asp:SqlDataSource>

<table style="width: 70%"  >
            <tr>
                <td style="height: 139px">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource3" GridLines="Vertical" HorizontalAlign="Left" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3">
                        <AlternatingRowStyle BackColor="#DCDCDC" />
                        <Columns>
                            <asp:BoundField DataField="Company_Name" HeaderText="Company- Top 3 Stocks" SortExpression="Company_Name" />
                            <asp:BoundField DataField="Location" SortExpression="Location" />
                           
                            <asp:BoundField DataField="Description" SortExpression="Description" HeaderText="Description"/>
                            <asp:ImageField DataImageUrlField="Picture"></asp:ImageField>
                            <asp:TemplateField HeaderText="Rating" SortExpression="Rating">
                                          <ItemTemplate><h1><%# getrating(Eval("Stars"))%></h1></ItemTemplate>
                                          </asp:TemplateField>
                            </Columns>
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                        <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                        <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                        <SortedAscendingCellStyle BackColor="#F1F1F1" />
                        <SortedAscendingHeaderStyle BackColor="#0000A9" />
                        <SortedDescendingCellStyle BackColor="#CAC9C9" />
                        <SortedDescendingHeaderStyle BackColor="#000065" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString16 %>" ProviderName="<%$ ConnectionStrings:ConnectionString16.ProviderName %>" SelectCommand="SELECT [Company_Name], [Location], [Stars], [Description], [Picture] FROM [sms_moneydata]">
                    </asp:SqlDataSource>
                </td>
                <td>&nbsp;<input type="button" value="Add Comments" class="button" style="float: right; width: 119px; top: 0px; left: 0px;" onclick="return window.open('/Account/AddComment.aspx', 'mywindow', 'menubar=1,resizable=1,width=650,height=400,top=100,left=400');" </td>
            </tr>
            <tr>
                <td style="width: 183px">  <td/>
                <td style="width: 183px"> </td>
            </tr>
        </table>
    <address>
        <i class="icon-envelope"></i><strong>Support:&nbsp;&nbsp;&nbsp;&nbsp;  </strong><a href="mailto:genedarocha@gmail.com">Marketing@SmartMoneySaver.com</a><br />
        <i class="icon-envelope"></i><strong>Marketing:</strong> <a href="mailto:genedarocha@gmail.com">Support@SmartMoneySaver.com</a>
    </address>
        </header>

</asp:Content>
